package com.sky.mapper;

import com.sky.pojo.Courier;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CourierMapper {

    /**
     * 根据订单号查询骑手
     */
    @Select("select courier_id from tb_trade_order where order_number = #{orderNo}")
    Long queryCourierByOrderNo(String orderNo);

    @Select("select * from tb_courier where id = #{id}")
    Courier queryById(Long id);
}
